UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCHEDZ2KYYl5gQAaJf+48RmO+vpcr7wGLnc88gq5Pms='
WHERE
key_id = 'b2301998d2024e5fa24d6c2af29e995071513528fdbca839b7fb4826040eeaad'
AND (
token = 'pCHEDZ2KYYl5gQAaJf+48RmO+vpcr7wGLnc88gq5Pms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)