UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gOD+cTCy9YLmGZL08w0d4IUfMqGzUrxDW3pAzu8M7sM='
WHERE
key_id = '3682a0d493bf407692f84db1a537c0c0abf6adc4e843a919b7278f3fdcb4a250'
AND (
token = 'gOD+cTCy9YLmGZL08w0d4IUfMqGzUrxDW3pAzu8M7sM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)