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