UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/hf+xf4Co87i3Sw9XYplWKrl1iy36wxruD7r0ydf+WI='
WHERE
key_id = '221106772a693a27cee92a53de976f6f6562e9755636bcfe41a319a6a1986af3'
AND (
token = '/hf+xf4Co87i3Sw9XYplWKrl1iy36wxruD7r0ydf+WI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)