UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0ZoP2poByO3L2Tq4mucOYtP4c1Qwx1y8vzdoXfFPLg='
WHERE
key_id = 'bbb40f0f88fa1f1d66e04429ed924be40e5cd5741c97786c55fb54a0382f8356'
AND (
token = 'X0ZoP2poByO3L2Tq4mucOYtP4c1Qwx1y8vzdoXfFPLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)