UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4qkhkE6qtHGUfXWrlHvfLrwncwqzBQfpe/I12ZyeBbs='
WHERE
key_id = '466c6bd8bf15bce4ec93a8a8707b07a02251d2bd2c23dc604fc167f249e74257'
AND (
token = '4qkhkE6qtHGUfXWrlHvfLrwncwqzBQfpe/I12ZyeBbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)