UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vX2ohrIWyKx0CDLE6O6ANnb8cGVE4L91e0A/WtctBEI='
WHERE
key_id = '2ea386dc1ed5803afea2e970c21ced339787043bcad68143a48f7e7e95d27ec3'
AND (
token = 'vX2ohrIWyKx0CDLE6O6ANnb8cGVE4L91e0A/WtctBEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)