UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8kH9WoWBLE68JCcd4+lXVu4mTtimuaSaVUl0xPJ8E9M='
WHERE
key_id = 'a47f98f1ef2a05e68f8da44baecfb45be15a62a16c8fd94654803924dec49c65'
AND (
token = '8kH9WoWBLE68JCcd4+lXVu4mTtimuaSaVUl0xPJ8E9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)