UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8sYyfIXVm09YfYV84TastxqkRCA1I4sxruscyATp2nc='
WHERE
key_id = 'fc4d3843c5c26a0d2ea14184c2f7737f4ace4967b2f62128081664dc6a62b077'
AND (
token = '8sYyfIXVm09YfYV84TastxqkRCA1I4sxruscyATp2nc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)