UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZffptc7lro/3OHELB3Ud2LH1Dd8050tTIUdW31MReU='
WHERE
key_id = '8c01d6f1fe4619f4b52d3e25ec9550a9979187eef55b5f2ac2c3ba7e9ab6fa97'
AND (
token = 'xZffptc7lro/3OHELB3Ud2LH1Dd8050tTIUdW31MReU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)