UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '048ZFtjfR94M3FA33yKw44es+T0fop6ajZGgCnTJbRc='
WHERE
key_id = '7e77b33f45752690021e5075345537a5e442ceafe495d25cb2e19ca7e05a0601'
AND (
token = '048ZFtjfR94M3FA33yKw44es+T0fop6ajZGgCnTJbRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)