UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g/bDGtjWZD23ks2O7Vx3xEr8vykLksKPBM6/bg4DUhM='
WHERE
key_id = '06996b875908b7eee3ac86320f6287fc6d638cd541fa1f2f9e73b25a9e14b25d'
AND (
token = 'g/bDGtjWZD23ks2O7Vx3xEr8vykLksKPBM6/bg4DUhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)