UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJTz/jQg28MvVIz6KLZ0L9ceNe0rcGGxpifAbggmawE='
WHERE
key_id = 'ca56a5e0905cf9146bd87f7d3143ab95d433c022a0accad46776121d49b92ee3'
AND (
token = 'zJTz/jQg28MvVIz6KLZ0L9ceNe0rcGGxpifAbggmawE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)