UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0oAgL6KSPBxfXP9tWj8JsRglKWsyOD1nZYDK8SJTN/s='
WHERE
key_id = '01663fa7ecc49944b26596a51084fddc96f33d97a6766a65e038f29a4c0a237b'
AND (
token = '0oAgL6KSPBxfXP9tWj8JsRglKWsyOD1nZYDK8SJTN/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)