UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkSuuqg4Dl4Uf3sm/gcH5MjE/sMCK/4expslL185WWk='
WHERE
key_id = 'b1704e8926bcd3648d7571efa2211380e6bf858ccab540196f5b59426a6b3347'
AND (
token = 'zkSuuqg4Dl4Uf3sm/gcH5MjE/sMCK/4expslL185WWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)