UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XW052sxbUSMKLQi9J8ntyEqqNn36ZjDtQbmbNUR//28='
WHERE
key_id = 'a55e9a605d6c74b5f34c27a4a4de1b742c2cad581afcf91fd6d80f553fc9b78d'
AND (
token = 'XW052sxbUSMKLQi9J8ntyEqqNn36ZjDtQbmbNUR//28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)