UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Xs0573WrONC8EcOzKhkB1g+ALfyV3KfaCI+zpBhb3M='
WHERE
key_id = 'a1f3e4d3cbd9aadc7d2697e1ba0ee8914b0a00240ea26d1a3fef4d055a91979e'
AND (
token = '6Xs0573WrONC8EcOzKhkB1g+ALfyV3KfaCI+zpBhb3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)