UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ztoAFcv0zieHGMN2ApqFiJfqBHLpuC4DV2gC5qusyU='
WHERE
key_id = '50852a2b2c2561565c8f2ec21420ff84d841c7639426eb403b4dc7570286748a'
AND (
token = '+ztoAFcv0zieHGMN2ApqFiJfqBHLpuC4DV2gC5qusyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)