UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kfxbFNi6Kg7WiF5IJkwKV7fGdgdVmBdgYxann9XkDOM='
WHERE
key_id = '6fe1d4e8242b4cf91900ee562d61fcc4f3efe865f7a5e0c5187fb0be7ea71359'
AND (
token = 'kfxbFNi6Kg7WiF5IJkwKV7fGdgdVmBdgYxann9XkDOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)