UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dRGjAkeGT34c0B1V7c4MC+MzYKczhF1m+xYmj46MxEw='
WHERE
key_id = '4b7ba7ded43987d2367cf9a4117293ed8c2892477572f6d0b2996b541cedb907'
AND (
token = 'dRGjAkeGT34c0B1V7c4MC+MzYKczhF1m+xYmj46MxEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)