UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aF4wz6fMVoDWKOzqq3BiRcyW/4A0JljU4G0mT2+GZU='
WHERE
key_id = '54804c7c4fc516183596d71527acbb73fbf67cf508c15eba07856174af5d9252'
AND (
token = '7aF4wz6fMVoDWKOzqq3BiRcyW/4A0JljU4G0mT2+GZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)