UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'At7vnrsTW6v6U51BcBn90psEH+cI1rAJOFt5m9T5aOI='
WHERE
key_id = 'b63dbe8ed09bbffb71ff4ba9b90eceb002796625b37c7904f2052e651df4e782'
AND (
token = 'At7vnrsTW6v6U51BcBn90psEH+cI1rAJOFt5m9T5aOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)