UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D2pdg3endwI4knwdEaCR3l+IlwPqhw63+gjx/mGCoU4='
WHERE
key_id = '859485b5b4bc8a2518c138de3ee7fe9f0591df1d044babac611758930a3acbb9'
AND (
token = 'D2pdg3endwI4knwdEaCR3l+IlwPqhw63+gjx/mGCoU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)