UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDpCgZ1vgWW7P4shIWBM6QyfjaTUUsqFeTFRO1F/j8c='
WHERE
key_id = 'b9a110014df1d09c19680b201f15d69e924abe8874980d8542e6ee6e5a6827b0'
AND (
token = 'ZDpCgZ1vgWW7P4shIWBM6QyfjaTUUsqFeTFRO1F/j8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)