UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8l0FUQUEvkjtOVP8KLpAe/TSYOLWLQxRr+DYULI2sU='
WHERE
key_id = 'ffad6cc02cc8497b15fb4bf614db0210f4abb515117d8ff8d15929ebe0f59df0'
AND (
token = 'q8l0FUQUEvkjtOVP8KLpAe/TSYOLWLQxRr+DYULI2sU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)