UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gc1aSNv00IZN7zCzsJj2PU7UbLMNiBc0Y9dIohXRzHg='
WHERE
key_id = 'bf8e84a8b8b6e3fac0712c528a73e10f1cff8d469b2b991ed4de7ab64bfbc32f'
AND (
token = 'gc1aSNv00IZN7zCzsJj2PU7UbLMNiBc0Y9dIohXRzHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)