UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kCG8crMDX3X9A/1jlpIByhtq/xgvFGYdK0Q2eWqNPSM='
WHERE
key_id = 'ca3d48baec1298dfd66f32610836e141ad1661bfefa8974ef4878f32be166ea0'
AND (
token = 'kCG8crMDX3X9A/1jlpIByhtq/xgvFGYdK0Q2eWqNPSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)