UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9PPcN2YPkBPU9La8+YjEb613fNYcvE+TEt18BL+EC50='
WHERE
key_id = '0ef8702e6fa74c1c547627e755c803c42bdbd32545f622ae64571d13770d1033'
AND (
token = '9PPcN2YPkBPU9La8+YjEb613fNYcvE+TEt18BL+EC50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)