UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4o/9b1ECA1qAwFseUjkMs3tU0HWw1fDrM6jS0FnPVMc='
WHERE
key_id = '9f4df6020c25fa5ab3cc6bcd3c077960d4a69c62755f6256eb4b9fe333fd47b7'
AND (
token = '4o/9b1ECA1qAwFseUjkMs3tU0HWw1fDrM6jS0FnPVMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)