UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4xPTdMx7zO7pTvsc2keNEvxDmu3zZ846xOEwfG+u9U='
WHERE
key_id = '6e64460914bac891992c1a4b865e95d9c771403303b1a288f7beff4656ac22a5'
AND (
token = 'D4xPTdMx7zO7pTvsc2keNEvxDmu3zZ846xOEwfG+u9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)