UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E/p5ZEhkkaP1HN53k7myCFPCHb1h5ibGnVn/7ZHJlPo='
WHERE
key_id = 'a8966fc299a41506d9242306e5bf5750a42e7f1b4e35365c7a12787b83f312ca'
AND (
token = 'E/p5ZEhkkaP1HN53k7myCFPCHb1h5ibGnVn/7ZHJlPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)