UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8r7Qm7ZeMrN7UUSMpojLrhUCTepccJ21tEv+d+Uhw4Q='
WHERE
key_id = '5b92ddc0e681603d516b3e485bd2d09a9ba05de98cc78ffb444d972b2a4a7cb0'
AND (
token = '8r7Qm7ZeMrN7UUSMpojLrhUCTepccJ21tEv+d+Uhw4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)