UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2tuHo05wWKl4Ztek57MYr35652f6A81I6cIYBrsKHgs='
WHERE
key_id = '40eddb1858a3f92967196a8eebba9d60afe7a5e8239f5b4f0a2aa0628f58667a'
AND (
token = '2tuHo05wWKl4Ztek57MYr35652f6A81I6cIYBrsKHgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)