UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDE+Ga5t+wadJgnPQhyeBmbbS8GsaoPhGl5JxvR+0w8='
WHERE
key_id = '335bbfc8f944dab91f278718fca3ffe1d1cc96866d745a11cc5f64b1907f8003'
AND (
token = 'ZDE+Ga5t+wadJgnPQhyeBmbbS8GsaoPhGl5JxvR+0w8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)