UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LmOKIdofCL7gqXKLWKMpORpKVgdzbfeuF4KcZZM1y+g='
WHERE
key_id = 'b92302e8a1cbbfff0ac7ed09a69bedea4d6357e61b0fed7f77912cb29e6fdb30'
AND (
token = 'LmOKIdofCL7gqXKLWKMpORpKVgdzbfeuF4KcZZM1y+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)