UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lCZ2reYYl3Zi/J9w0QyKvHJyo91xkdFnoOmTlQ4+4ZU='
WHERE
key_id = 'bc6e9a32af7b408f318be512099cc254dee527dce0f75c5fde9e99b5aedb7bcd'
AND (
token = 'lCZ2reYYl3Zi/J9w0QyKvHJyo91xkdFnoOmTlQ4+4ZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)