UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5gxuIi2WnVyYMpkYtNZ3Teg7zQ3/JPI9odm8o0/82lw='
WHERE
key_id = 'b91c29033e5895a15bd7150ac56e47ecf083692c42ce15969d6046ff90f39804'
AND (
token = '5gxuIi2WnVyYMpkYtNZ3Teg7zQ3/JPI9odm8o0/82lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)