UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '05mefJjdsgPQbKyCOQfgrW4ZD8N1LzOro59ZRMiPIio='
WHERE
key_id = '5a9cccbb685ac6835fe54068f5f8f7ed9d9f17dc6ad40fede2ebb8cd4790dc6e'
AND (
token = '05mefJjdsgPQbKyCOQfgrW4ZD8N1LzOro59ZRMiPIio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)