UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'txi/UGQhieHfXdDILCoVG9DXviNZ5xG/kbK4Xtxsvwg='
WHERE
key_id = 'abc83938d0334dc7bdb4510b069900ff35b678fd1cf8c7e0227c629e247b9e6b'
AND (
token = 'txi/UGQhieHfXdDILCoVG9DXviNZ5xG/kbK4Xtxsvwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)