UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eq5ZhfSo2SvzgURJ2cKLhpP0jVycktDPZvorYA0jKP4='
WHERE
key_id = 'ec782cc1d94f7a917eb60c087f4172679e4deea48af4d289bdaa900ff8bdddee'
AND (
token = 'eq5ZhfSo2SvzgURJ2cKLhpP0jVycktDPZvorYA0jKP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)