UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yHcG6LdsFAL9apPnJHSsR2yq2ya2ZuU8xd0ZnY66R1E='
WHERE
key_id = 'e536a0b3512094311f1c66aca05e6ecce5fbb109d227624572318ee05513ec57'
AND (
token = 'yHcG6LdsFAL9apPnJHSsR2yq2ya2ZuU8xd0ZnY66R1E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)