UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pw1Pq/3eUZYs5czRkfCZYLSw9CTH+M5X6BGkUT18wwE='
WHERE
key_id = 'be986263c99f8878da63c0de3a5fa76423ffb2ad0c7f77cf06563b447510ba5e'
AND (
token = 'pw1Pq/3eUZYs5czRkfCZYLSw9CTH+M5X6BGkUT18wwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)