UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5hw70RKPhfKgo284BvMKmKD2r2WHhcNCTC9AMexnCoE='
WHERE
key_id = '27b42b87739797a1532e36fe4b4fadcb8a076aac9d1570e18594099c23c1f670'
AND (
token = '5hw70RKPhfKgo284BvMKmKD2r2WHhcNCTC9AMexnCoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)