UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pvbl5uhg1h70Em559aLMU9B0dtMzr16/BkxbbdaSFk4='
WHERE
key_id = 'cdf16111ee37e52b7af4c1d43dcc7f46d5d627c0c1de74d867355c413fe9ee1d'
AND (
token = 'pvbl5uhg1h70Em559aLMU9B0dtMzr16/BkxbbdaSFk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)